<%--
  Created by IntelliJ IDEA.
  User: lenovo
  Date: 2018/11/16
  Time: 18:40
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link href="${pageContext.request.contextPath}/statics/hplus/css/bootstrap.min.css" rel="stylesheet">
    <link href="${pageContext.request.contextPath}/statics/hplus/css/plugins/bootstrap-table/bootstrap-table.min.css" rel="stylesheet">
    <script src="${pageContext.request.contextPath}/statics/hplus/js/jquery.min.js"></script>
    <script src="${pageContext.request.contextPath}/statics/hplus/js/bootstrap.min.js"></script>
    <script src="${pageContext.request.contextPath}/statics/hplus/js/plugins/bootstrap-table/bootstrap-table.min.js"></script>
    <script src="${pageContext.request.contextPath}/statics/hplus/js/plugins/bootstrap-table/locale/bootstrap-table-zh-CN.min.js"></script>
    <script>


        function searcha() {
            //返回表格的 Options。
            var opts = $("#roletb").bootstrapTable("getOptions") ;
            var limit = opts.pageSize ;
            var offset = (opts.pageNumber-1) * limit;
            var username = $("#username").val() ;
            $.post("${pageContext.request.contextPath}/XiaoFeiTable/danju",{'id':username,'limit':limit,'offset':offset},function (data) {
                // var mydata = eval("("+data+")") ;
                //重新绑定表格数据
                $("#roletb").bootstrapTable('load',data) ;
            })
        }


        $(function () {
            $("#tapcanxq").bootstrapTable({
                url:"${pageContext.request.contextPath}/XiaoFeiTable/danjuhaoselect",
                //设置每页多少条数据
                pageSize:2,
                pageList:[2,4,8,16],
                height:300,
                pageNumber:1,
                //启用分页，但是默认情况下，是客户端分页的
                // pagination:true,
                // 启用服务器端分页
                 //sidePagination:'server',
                columns:[
                    {
                        field:'xiaofeimxtime',
                        title:'时间'
                    },
                    {
                        field:'huiyuan_Name',
                        title:'会员姓名'
                    },
                    {
                        field:'xiangmuleixing_Name',
                        title:'类型'
                    },
                    {
                        field:'fuwu_Name',
                        title:'名称'
                    },
                    {
                        field:'chanpindanwei_Name',
                        title:'单位'
                    },
                    {
                        field:'taocanfenlei',
                        title:'套餐消费'
                    },
                    {
                        field:'fuwu_shoujia',
                        title:'售价'
                    },
                    {
                        field:'shuliang',
                        title:'数量'
                    },
                    {
                        field:'xiaofeitableDanhao',
                        title:'单号'
                    },

                ]
            }) ;
            $("#roletb").bootstrapTable({
                url:'${pageContext.request.contextPath}/XiaoFeiTable/danju',
                //设置每页多少条数据
                pageSize:2,
                pageList:[2,4,8,16],
                height:300,
                pageNumber:1,
                //启用分页，但是默认情况下，是客户端分页的
                pagination:true,
                //启用服务器端分页
                sidePagination:'server',
                queryParams:function(params){
                    var temp = {  //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
                        limit: params.limit,  //页面大小
                        offset: params.offset, //页码
                        id:$("#username").val()
                    };
                    return temp;
                },
                columns:[
                    {
                        field:'jiezhangshijian',
                        title:'入库时间'
                    },
                    {
                        field:'dianpu_Name',
                        title:'消费店铺'
                    },
                    {
                        field:'huiyuan_Id',
                        title:'会员编号'
                    },
                    {
                        field:'huiyuan_Name',
                        title:'会员姓名'
                    },
                    {
                        field:'dianpu_Name',
                        title:'会员店铺'
                    },
                    {
                        field:'xiaofeijine',
                        title:'消费金额'
                    },
                    {
                        field:'chongzhi_Name',
                        title:'付款方式'
                    },
                    {
                        field:'danhao',
                        title:'单号'
                    },
                    {
                        field:'beizhu',
                        title:'备注信息'
                    },
                    {
                        field:'caozuoyuan',
                        title:'操作员'
                    },
                    {
                        title:'操作',
                        formatter:function(value,row,index){
                            var d=""+row.danhao;
                            return "<button class='btn  btn-primary' onclick='query("+d+")'>查询单据</button>"
                        }
                    },
                ]
            }) ;
        }) ;


        // function toadd() {
        //     $("#modelId").modal("show") ;
        // }


        // function query() {
        //     $("#showtaocanxq").modal("show") ;
        // }
        function query(danhao){
            $("#showtaocanxq").modal("show") ;
            $.post("${pageContext.request.contextPath}/XiaoFeiTable/danjuhaoselect",{'danhao':danhao},function (data) {
              // var mydata = eval("("+data+")") ;
                //重新绑定表格数据
                $("#tapcanxq").bootstrapTable('load',data) ;
            })
        }

    </script>

</head>
<body>


<div class="panel panel-default">
    <div class="panel-heading">
        <h3 class="panel-title">消费统计</h3>
    </div>



    <div class="panel-body">
        <div class="row">
            <div class="col-sm-6">
            </div>
            <div class="col-sm-6">
                <form  class="form-inline pull-right">
                    <input id="username" type="text" class="form-control">
                    <button class="btn btn-primary" onclick="searcha()" type="button"><span class="glyphicon glyphicon-search"></span>&nbsp;&nbsp;搜索</button>
                </form>
            </div>
        </div>
        <c:forEach items="list" var="h">
            <table class="table">
                <thead>
                <tr>
                    <th scope="col">汇总:</th>
                    <th scope="col">数量:</th>
                    <th scope="col">金额:</th>
                </tr>
                </thead>
            </table>
        </c:forEach>
        <div class="row">
            <div class="col-sm-12">
                <table id="roletb"></table>
            </div>
        </div>
    </div>
</div>








<!--套餐详情模态框-->
<div class="modal inmodal" id="showtaocanxq">
    <div class="modal-dialog">
        <div class="modal-content animated bounceInRight">
            <table id="tapcanxq"></table>
            <div class="modal-footer">
                <button type="button" class="btn btn-white" data-dismiss="modal">关闭</button>
            </div>
        </div>
    </div>
</div>







</body>
</html>